﻿using System;
using System.Collections.Generic;
using System.Text;

using System.Data;
using System.Data.Common;

namespace DataBaseManger
{
    interface IDataBaseHelper
    {
        void Open();
        void Close();
        int ExecuteNonQuery(string sSQL);
        int ExecuteNonQuery(string sSQL,CommandType cmdType);
        int ExecuteNonQuery(string sSQL, CommandType cmdType,params DbParameter[] cmdPara);
        DataSet ExecuteQuery(string sSQL);
        DataSet ExecuteQuery(string sSQL, CommandType cmdType);
        DataSet ExecuteQuery(string sSQL, CommandType cmdType,params DbParameter[] cmdPara);
        object ExecuteScalar(string sSQL);
        object ExecuteScalar(string sSQL,CommandType cmdType);
        object ExecuteScalar(string sSQL, CommandType cmdType, params DbParameter[] cmdPara);
        DbDataReader ExecuteReader(string sSQL);
        DbDataReader ExecuteReader(string sSQL,CommandType cmdType);
        DbDataReader ExecuteReader(string sSQL, CommandType cmdType,params DbParameter[] cmdPara);

    }
}
